Setting Trigger Properties

Trigger Name
Set the trigger name.

Compound
Check to set the trigger as a compound trigger.

For each
Set the trigger as a row trigger or statement trigger.

Fires
Specify the trigger timing whether the trigger action is to be run before or after the triggering statement.

  • DELETE - fires the trigger whenever a DELETE statement removes a row from the table or removes an element from a nested table.
  • INSERT - fires the trigger whenever an INSERT statement adds a row to a table or adds an element to a nested table.
  • UPDATE - fires the trigger whenever an UPDATE statement changes a value in one of the columns specified in Update Of. If no Update Of are present, the trigger will be fired whenever an UPDATE statement changes a value in any column of the table or nested table.
  • Update Of
    Specify the fields for UPDATE statement trigger upon necessary. Click to select field(s).

    Enable
    You can choose whether to enable / disable the trigger constraint by checking / unchecking the box.

    Body
    Type in the definition for the trigger.

    Example:
        BEGIN
          add_job_history(:old.employee_id, :old.hire_date, sysdate,
                      :old.job_id, :old.department_id);
        END;
      

    Hint: To customize the view of the editor and find out more features for sql editing, see Editor View and More Features.

    Advanced

    Referencing
    Specify correlation names. The default correlation names are OLD and NEW.

    When
    Specify the trigger condition, which is a SQL condition that must be satisfied for the database to fire the trigger. This condition must contain correlation names and cannot contain a query.

    Schema
    Define the trigger on the current schema.

    Follows
    Specify the relative firing order of triggers of the same type.